-- pre populate for test 
INSERT INTO [users] ( username, password ) VALUES ('demo','demo');
GO

-- Question 1
INSERT INTO question( question, exam_id )
VALUES ( 
	'<cfoutput> with the GROUP attribute requires which SQL clause in the SQL query? (select 1)',1
)
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'GROUP BY', 1, 1 )
GO
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'ORDER BY', 1, 0 )
GO
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'JOIN', 1, 0 )
GO
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'WHERE', 1, 0 )
GO

-- Question 2
INSERT INTO question( question, exam_id )
VALUES ( 
	'Where are APPLICATION variables stored?  (select 1)',1
)
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'Server memory', 2, 1 )
GO
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'Server cookies', 2, 0 )
GO
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'Database', 2, 0 )
GO
INSERT INTO answer( answer, question_id, is_correct )
VALUES( 'Client cookies', 2, 0 )
GO

-- Preparing user attempts
INSERT INTO attempt ( is_finish, final_mark, user_id )
VALUES ( 0, NULL, 1 )
GO
INSERT INTO attempt_question ( attempt_id, question_id, user_answer_ids, is_correct )
VALUES ( 1, 1, NULL, NULL )
GO
INSERT INTO attempt_question ( attempt_id, question_id, user_answer_ids, is_correct )
VALUES ( 1, 2, NULL, NULL )
GO
